"""
    excel操作
"""
from openpyxl import load_workbook


workbook = load_workbook(filename='../source/薪酬实发信息.xlsx')
sheet = workbook.worksheets[0]

for row in sheet.iter_rows(values_only=True, min_row=2):
    print(row)
    print(f"update fsp_eas.fea_boe_header set name = '{row[1]}' where code = '{row[0]}' ;")
# 读取指定单元格的数据
#cell_value = sheet['A1'].value
#print(cell_value)

# 也可以使用行和列的索引来读取单元格数据
#cell_value_by_index = sheet.cell(row=1, column=1).value
#print(cell_value_by_index)